Setting Up Data and Parameters
The Data & Parameters panel enables you to set up the datasets used in your report. You can only select one dataset per report. You must create parameters before you can add them to a report.
Parameters enable you to filter data and display information in the report. They are user-defined variables that are only available inside the report.
To select your dataset
- Before you can create a parameter, you must select the dataset. On the right-side menu, click to display the Data & Parameters panel.
Click Select Dataset. The Select Dataset dialog displays. The functionality to create a connection is the same as the Connections feature in Qrvey Composer. For more information, see Connections.
Once you’ve established the connection, the dataset columns display in the panel as Categories and Values. They are now available for use in the report.
To create a parameter
- Display the Parameters tab of the Data & Parameters panel.
- Click Add Parameter. The New Parameter dialog displays.
- Complete the fields provided and click Save. For information on the properties, see the next section, To edit a parameter.
To edit a parameter
- Display the New Parameter or Edit Parameter dialog for the parameter.
Enter the Parameter Name in the field provided. It must be unique, and it cannot use special characters.
Enter helpful text in the Parameter Label field. This text displays in the parameter’s preview panel.
In the Data Type dropdown, select Numeric, Text, or Date Time.
Select whether the parameter is Visible or Hidden. If set to Visible, you will be prompted to provide a value when using the Preview feature. If set to Hidden, you will either need to define a default value or select Allow Null Value.
To enable the parameter to accept an empty/null value, select Allow Null Value.
To enable the parameter to accept an empty string as a value, select Allow Blank Value. This option is only available for Text parameters.
To define a default value, select Specify Default Value. Enter the desired value in the Default Value field.
Click Save.
See also: